package com.tupu.mapper.dispatch;

import com.tupu.entity.dispatch.SignalmissingData;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;

/**
* @author 15702
* @description 针对表【tb_signalmissing_data】的数据库操作Mapper
* @createDate 2023-11-22 17:32:20
* @Entity com.tupu.entity.dispatch.SignalmissingData
*/
public interface SignalmissingDataMapper extends BaseMapper<SignalmissingData> {

    @MapKey("device_type")
    List<Map<String, Object>> deviceTypePercentage(@Param("station") String station,@Param("startTime") LocalDateTime startTime,@Param("endTime") LocalDateTime endTime,@Param("deviceType") String deviceType);

    @MapKey("station")
    List<Map<String, Object>> stationPercentage(@Param("deviceType") String deviceType,@Param("startTime") LocalDateTime startTime,@Param("endTime") LocalDateTime endTime,@Param("station") String station);

    List<Map<String, Object>> signalOmissionPointTableMsgStationTop5(@Param("deviceType") String deviceType,@Param("startTime") LocalDateTime startTime,@Param("endTime") LocalDateTime endTime);
}




